#посмотреть
▫️Условия задачи
▫️Создание таблицы для экспериментов в PostgreSQL
▫️Объединение таблицы с самой собой (SELF JOIN)
▫️Записываем условие фильтрации
▫️Проверка решения на Leetcode
BY SQL для тестировщика
The SSE was the first modern stock exchange to open in China, with trading commencing in 1990. It has now grown to become the largest stock exchange in Asia and the third-largest in the world by market capitalization, which stood at RMB 50.6 trillion (US$7.8 trillion) as of September 2021. Stocks (both A-shares and B-shares), bonds, funds, and derivatives are traded on the exchange. The SEE has two trading boards, the Main Board and the Science and Technology Innovation Board, the latter more commonly known as the STAR Market. The Main Board mainly hosts large, well-established Chinese companies and lists both A-shares and B-shares.
SQL для тестировщика from de